UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pyedcnO2BxrhgJTEuIywFNytfKEG3sPyd/sJh2e2BYg='
WHERE
key_id = 'e88a7c0cd695e74e34259e32b7d9ee91237ebb74c7d9b470dc58b2c3c320f390'
AND (
token = 'pyedcnO2BxrhgJTEuIywFNytfKEG3sPyd/sJh2e2BYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)