UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mNPpNvKUMcp8pKpCOdveKFgs5KPFy77IWwhIsHU9DUQ='
WHERE
key_id = '65477f781064bdd5ef801e40fa1a1c4acc5a076b98dad1104b4b535b8e22abb8'
AND (
token = 'mNPpNvKUMcp8pKpCOdveKFgs5KPFy77IWwhIsHU9DUQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)