UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8GFoIGESYr9mPBs0RC6nxdBOp2WtDlP69vGBX0hDABU='
WHERE
key_id = '9d836306b84a75fe20c6dce2656d12a03efa7c0f7a604a577f58575d0ccfc39f'
AND (
token = '8GFoIGESYr9mPBs0RC6nxdBOp2WtDlP69vGBX0hDABU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)