UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f0HofnDIiJ4462dEWCTVaj3kIRu7u7J8zEkCuuXERjY='
WHERE
key_id = '35c70f772d22b6f718879ba772f5d1b0b918df0c3fa6218b44de2a7ce179bd3c'
AND (
token = 'f0HofnDIiJ4462dEWCTVaj3kIRu7u7J8zEkCuuXERjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)