UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zEdSG2eLnXW48hf1eALiiuIFOaqw9bdx6TyGgPHYbw='
WHERE
key_id = 'c2aa8fbb4100573fb8b39244df5506c12c97f998dfacdbf3656ebbf5c07e94d9'
AND (
token = '6zEdSG2eLnXW48hf1eALiiuIFOaqw9bdx6TyGgPHYbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)