UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9VAq3wpVMUaGbF/lqyjkO3eaOAg6K+N3k7V63w35AT0='
WHERE
key_id = '1a9afd831d1bae05f293bdb7d9d21f12647070e9272dbb02128fb2548ffcf529'
AND (
token = '9VAq3wpVMUaGbF/lqyjkO3eaOAg6K+N3k7V63w35AT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)