UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YJt86W9Op91cvc7vqzZQNnqoqiLwvHE6pXh9CSi64js='
WHERE
key_id = '48ce37683125256d8dde3b38b5787b2275388ab8cb53edb47d6405789747946a'
AND (
token = 'YJt86W9Op91cvc7vqzZQNnqoqiLwvHE6pXh9CSi64js='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)