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