UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gwDOJQVjVSwJ59YjXHVsebNZlFiRqDKt2vdH7zmLviQ='
WHERE
key_id = 'f147f95ea2f81af9c10a1988a17f76b26f2b38eb96bf2ccec94d26e74527bd63'
AND (
token = 'gwDOJQVjVSwJ59YjXHVsebNZlFiRqDKt2vdH7zmLviQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)