UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WnOUKGfT2vt7+N67eWYFBSga4cfJIhLmGiVckYcfrNM='
WHERE
key_id = '05f1d31b403864408d7cf5f2ada74640b503c252a83a35f498f5c5695a7c584f'
AND (
token = 'WnOUKGfT2vt7+N67eWYFBSga4cfJIhLmGiVckYcfrNM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)