UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BxUhYjzOijlE8z3iBLsO4f5DZieqBwx6N+6uWx1jKr4='
WHERE
key_id = 'a8ec65cdc589eea5a81f69dfa2179a6e80b6c9f05d1ae36adce6a48214fa7755'
AND (
token = 'BxUhYjzOijlE8z3iBLsO4f5DZieqBwx6N+6uWx1jKr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)