UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X/mso1mPqNcg2BXn3ygzt4PezCgWUu/iwR6HWY6GZjU='
WHERE
key_id = '5b3b573b57c7a94374a59ed64a01e01912938d3b9a42e5adb0acd5071ddeb58f'
AND (
token = 'X/mso1mPqNcg2BXn3ygzt4PezCgWUu/iwR6HWY6GZjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)