UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TE+y/Yd2gCIaKtnW9VrHvhiklPxwDcA6mfFk7u27gPg='
WHERE
key_id = '3748f318345fbaa876ceb065e1e5e7e5197d6882162db03cd8f5663411f5f403'
AND (
token = 'TE+y/Yd2gCIaKtnW9VrHvhiklPxwDcA6mfFk7u27gPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)