UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHb5soZUm1OKkJ5CXA+e+LLIUxK0EE/EWcibyUNiWns='
WHERE
key_id = '4bc94073a9fa6c8bcecb85311c93d73608b2d8d70e99565edb347ad29c5885dd'
AND (
token = 'xHb5soZUm1OKkJ5CXA+e+LLIUxK0EE/EWcibyUNiWns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)