UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cPxzasXHcAQzTDRX9eSjJeRRbuGCoKuRsmCMcLt/zz0='
WHERE
key_id = 'e8240f5293ff67ac648f622c1d7d33c462b02d7f9e5a60fb7739255acefcdd4f'
AND (
token = 'cPxzasXHcAQzTDRX9eSjJeRRbuGCoKuRsmCMcLt/zz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)