UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6rWIPgL/WL9yG2w6D41ucOdX1Lwdb+bUER7E3XW/cfY='
WHERE
key_id = '3a422065cbd21c4e9c9113e894285303ec371ad8b80bac71970d165ddd643408'
AND (
token = '6rWIPgL/WL9yG2w6D41ucOdX1Lwdb+bUER7E3XW/cfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)