UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TCJbtNk35HF4Ti6bhRlfK79NuAnDBzlCiR7f4af72zM='
WHERE
key_id = 'e93ca321d45a6c7a6609eb0d72a8f591130351e0857d72ec70e42defa77fc720'
AND (
token = 'TCJbtNk35HF4Ti6bhRlfK79NuAnDBzlCiR7f4af72zM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)