UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f8BJwppsQXUY1qlo344EWlzSfKDZdSNOain6m4sCBis='
WHERE
key_id = '9cd85d2c9043d5331e9290dc5d4b7efd092ef11c70be224223f43d1eec8c3939'
AND (
token = 'f8BJwppsQXUY1qlo344EWlzSfKDZdSNOain6m4sCBis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)