UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd0li2QCFEJUU9LPxUQmJazuug7G+Y7cgvgfVl4mxgA0='
WHERE
key_id = '18fc86e2334d33d7999e65ac10578d62302570dbb026530399bd83ba191fb09c'
AND (
token = 'd0li2QCFEJUU9LPxUQmJazuug7G+Y7cgvgfVl4mxgA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)