UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pPClwVJpUfGxT39DoOKz2BRLt9rY1x1mn17wEW/EQpU='
WHERE
key_id = 'e25bbfb49b488c9241b366f54295a6a2a9210c8ff63e03b6d9bb746309fbae5d'
AND (
token = 'pPClwVJpUfGxT39DoOKz2BRLt9rY1x1mn17wEW/EQpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)