UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8faYAVSmX8t6Y0ywOSpQWHz542765SzzD5RWq+PzSgY='
WHERE
key_id = 'f80a40a8e0e844a798787620ab8d0a18fc2d346eceed31a4889ce66e6db47a93'
AND (
token = '8faYAVSmX8t6Y0ywOSpQWHz542765SzzD5RWq+PzSgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)