UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/CThX3t8knYHWd74YyZONq2HfJ2/aGfDarCL4JHOjR4='
WHERE
key_id = '64590bf97b66991b0c0fa2d0193840bf478365b2561c95316f238aca58191b5e'
AND (
token = '/CThX3t8knYHWd74YyZONq2HfJ2/aGfDarCL4JHOjR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)