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