UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JE+oMkg9/7mOYysn6dGxJDwurW8RqYV7JfYzPHhmIzc='
WHERE
key_id = 'bbf3b8b49e40663734f1e99ae2691157a2527e66aea033e1a987ad83becec972'
AND (
token = 'JE+oMkg9/7mOYysn6dGxJDwurW8RqYV7JfYzPHhmIzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)