UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qV8JwOAj0WfhJVAuQq62LdiSg36eN+O9hIXG38xpHAA='
WHERE
key_id = 'b3c1df696f1143a36f0ba608e203bb8c74ea9fa6908956cfd68fe14f7ae2423d'
AND (
token = 'qV8JwOAj0WfhJVAuQq62LdiSg36eN+O9hIXG38xpHAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)