UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'liEVh75rCNtOnfjxnz2qZ4GkpRbEeUT3s89G/PcGmc4='
WHERE
key_id = '3bd18f9f85e3fbd7a492643bbccc506cef1011de5c82fc44e8336a62aaad4ab5'
AND (
token = 'liEVh75rCNtOnfjxnz2qZ4GkpRbEeUT3s89G/PcGmc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)