UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DsJWszydIIeln46n+NYU80UEwvTrKaUXrEKyY5Tk4LM='
WHERE
key_id = '99b227b9fc3eea150374a17a60324eac2725647b076b5d7268f6df0a6ad3fed5'
AND (
token = 'DsJWszydIIeln46n+NYU80UEwvTrKaUXrEKyY5Tk4LM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)