UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AI+0exLpbY5gW69j2p5PqCjzRVa/RrEKx/6E5QyIFdw='
WHERE
key_id = 'dfb6d2fde41c19bbc84cf4410668652b65098aa936b4068cf7681a499de453e7'
AND (
token = 'AI+0exLpbY5gW69j2p5PqCjzRVa/RrEKx/6E5QyIFdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)